﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace ATM
{
    class CreateTables
    {
        private SqlConnection dbCon;

        public SqlConnection DbCon
        {
            get { return dbCon; }
            set { dbCon = value; }
        }

        public CreateTables()
        {
            this.ConnectToDb();
        }
        
        public void ConnectToDb()
        {
            dbCon = new SqlConnection("Server=.\\SQLEXPRESS; " +
                "Database=Northwind; Integrated Security=true");
            dbCon.Open();
        }

        public void CardAccounts()
        {
            SqlCommand cmd = new SqlCommand(
            "CREATE TABLE CardAccounts (" +
                "Id int NOT NULL,"+
                "Id int NOT NULL," +
                "Id int NOT NULL," +
                "Id int NOT NULL," +
        //        CONSTRAINT PK_Person PRIMARY KEY CLUSTERED (num ASC) 
        //ON [PRIMARY] 

            ")", this.DbCon);
        }
    }
}
